Use the data labels options to show or hide data labels, and to customize data label fonts, colors, formats, and more. The Data Labels options are available for all charts, bubble and heat maps. To learn about shape map data labels, click here.
Formatting Data Labels
Data labels can be adjusted from both the Formatting panel and the Component ribbon.
Formatting Panel
Turn on Data Labels
Data labels are disabled by default. Start by turning them on by selecting the Data Labels checkbox at the top of the panel (purple highlight above). Data labels can also be enabled or disabled from the Component ribbon.
Position the Labels
From the Position drop-down (green highlight above), choose the position of the data labels.
- Optimized: Pyramid will determine the optimal data label settings.
- Inside: place data labels inside the chart segments.
- Outside: place data labels outside the chart segments.
- Inside Top: (supported for column charts only) place data labels inside the top of each column.
- Inside Middle: (supported for column charts only) place data labels inside the middle of each column.
- Inside Bottom: (supported for column charts only) place data labels inside the bottom of each column.
- Outside: place data labels outside the chart segments.
Label Optimization
- Optimize Outside Labels: appears when position is set to Optimized or Outside for segment charts only.
- Allow Labels Overlap: show labels that overlap with each other.
- Overlap Tolerance: labels with a collision percentage above the given amount will not be shown.
Label Font
Adjust font type, size, and style for the data labels (blue highlight above).
- Font: change the font type.
- Size: change the font size.
- Style: change the font style (bold, italics, or color).
- Background Color: change the background color for data labels.
Content
Adjust the content of the data labels (yellow highlight above). By default, data labels show the numeric value of each segment, but you can add more information to the labels.
- Value: set the units for the data labels. Choose Auto to let Pyramid set the units, or select thousands, millions, or billions. Choose Off if you don't want to display units.
- Series: add the data series to the label (this will correspond to the legend).
- Category: add the hierarchy category to the label (this will correspond to the categories on the x-axis).
- Percentage: when working with segment charts and stacked 100% column charts, this option will be enabled instead of Category. Use it to show the segment value as a percentage of the total.
- Add Line Break: display each selected data label content type on a new line.
Choose the Data Series
If the report features a legend driven by a hierarchy in the color drop zone, a data series drop down will appear (red highlight above). To apply formatting changes to every series in the report, make changes will the selection is set to Default.
If you want to make changes to a given series only, select the relevant series before applying formatting changes (as in the image below). You can then show or hide data labels for the given series (ref highlight below), and apply any formatting changes as required.
You can further edit each data series using the color formatting capabilities (when selecting Color from the Formatting panel drop-down.
Data Labels for Stacked Column Charts
Data labels in Stacked Column charts can be displayed in two ways:
If you want to display a label for each segment of the column (highlighted for one column below), select the Data Labels checkbox as above:
Adding Total Labels
If
you only want an overall total for each column, leave the Data Labels checkbox unchecked, and instead click the label totals button 
, then the Show Total Labels checkbox as shown below in the orange box.
The total value will be added to each stacked column as shown below (red circles).
Component Ribbon
Toggle data labels on and off from the Component ribbon:
Examples
Example 1
In this example, data labels were positioned outside and bolded:
Example 2
In this example, the value, percentage, and data point are displayed in the data labels with a line break between each label:
Example 3
Here, the data labels were formatted differently for each data series. For Customer (in blue) the labels were simply set to bold. For No Discount (in red), the labels were placed outside, with a background color applied, and both series and category were enabled. For Reseller (in yellow) the labels were placed at the top and italicized, and the series label was enabled.
Example 4.
In this example, both data labels (purple arrows below) and total labels (green arrows below) were added to the stacked column chart to display the value for each segment, and the total value of each column:
